l104/opdrachten in de les/auteurdetail.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<?php
include ('../db.php');
$auteurnr = $_GET['auteurnr'];
$query = "SELECT * FROM auteurs a where a.auteurnr = $auteurnr ";
$result = mysqli_query($db, $query) or die ('Error: ' . $query);
$row = mysqli_fetch_assoc($result);
echo "<h1>$row[voornaam] ($row[voorletters]) $row[tussenvoegsel] $row[achternaam]</h1>";
echo "<div>$row[geb_jaar] - $row[sterfjaar]</div>";
echo "<br>";
echo "<div>Auteurnummer: $row[auteurnr]</div>";
echo "<br>";
echo "<h3>Geschreven boeken</h3>";
$query = "SELECT * FROM boeken b where b.auteurnr = $auteurnr";
$result = mysqli_query($db, $query) or die ('Error: ' . mysqli_error($db));
echo "<table>";
echo '<tr>';
echo '<th>Titel</th>';
echo '</tr>';
while ($row = mysqli_fetch_assoc($result)){
echo "<tr><td><a href='boekdetail.php?boeknr=$row[boeknr]'>$row[titel]</a></td></tr>\n";
}
echo "</table>";
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse